KPI % 12
In this step we are going to continue to create 4 KPI percentages:-

DAX calculation for Mortality rate

 Mortality Rate = CALCULATE(DIVIDE([Total Deaths],[Total Cases],0),'COVID-19 In US'[date])+0


Steps for this report

Go to our report page to work on our card for Mortality Rate %.

1. Drag and drop card from visualization.

2. Drag and drop Mortality rate % measure from measure table in fields.

3. Add a title text and use same format through out the dashboard. (Refer step 4)

4. Customize Data label

5. Category - off

6.  Boarder - on




Calculated Columns:
_Last Week Total Case = 
Var __Last Week= DATEADD('COVID-19 In US'[date],-7,DAY)
Return
CALCULATE(MAX('COVID-19 In US'[positive Increase]) ,
FILTER('COVID-19 In US' ,
'COVID-19 In US'[date] = __Last Week
))+0
_Last Week Total Deaths = 
Var __Last Week= DATEADD('COVID-19 In US'[date],-7,DAY)
Return
CALCULATE(MAX('COVID-19 In US'[death Increase]) ,
FILTER('COVID-19 In US',
'COVID-19 In US'[date] = __Last Week

))+0

DAX calculation for Death WOW% :  

           Death WoW% = 
VAR __Previous Week =
DIVIDE(MAX('COVID-19 In US'[_Last Week Total Deaths]),MAX('COVID-19 In US'[_Last Week Total Case]),0)
Return
DIVIDE(([Mortality Rate]- __Previous Week),__PreviousWeek,0)+0


Conditional Formatting:

          Death WOW% Sign = SWITCH(TRUE(),'Measure'[Death WoW%]>0,UNICHAR(9650),
                              [Death WoW%]<0,UNICHAR(9660),UNICHAR(9644))&ROUND([Death WoW%],1)&"%"             
Death WOW% Color = IF([Death WoW%]>0,"#fa8264","#1c9407")



Steps for this report

Go to our report page to work on our card for  Death WOW %.

1. Drag and drop card from visualization.

2. Drag and drop Death WOW% sign measure from measure table in fields.

3. Add a title text and use same format through out the dashboard. (Refer step 4)

4. Customize Data label

5. Category - off

6.   Boarder - on




DAX calculation for Infection Rate%:

               Infection Rate = CALCULATE(DIVIDE([Total Cases],[Total Infection],0),'COVID-19 In US'[date])+0
Total Infection = SUM('COVID-19 in US'[total Test Results Increase])



Steps for this report

Go to our report page to work on our card for Infection Rate %.

1. Drag and drop card from visualization.

2. Drag and drop Infection rate % measure from measure table in fields.

3. Add a title text and use same format through out the dashboard. (Refer step 4)

4. Customize Data label

5. Category - off

6.   Boarder - on


DAX calculation for Infection WOW% :  

                Infection WoW% = 
VAR __Previous Week =
DIVIDE(MAX('COVID-19 In US'[_Last Week Total Case]),MAX('COVID-19 In US'[_Last Week Total Test]),0)
Return
DIVIDE(([Infection Rate]- __Previous Week),__PreviousWeek,0)+0


Calculated Columns:

_Last Week Total Test = 
Var __Last Week= DATEADD('COVID-19 In US'[date],-7,DAY)
Return
CALCULATE(MAX('COVID-19 In US'[total Test Results Increase]) ,
FILTER('COVID-19 In US',
'COVID-19 In US'[date] = __Last Week
))+0


Conditional Formatting:

        Infection WOW% sign = SWITCH(TRUE(),'Measure'[Infection WoW%]>0,UNICHAR(9650),
[Infection WoW%] <0,UNICHAR(9660),UNICHAR(9644))&ROUND([Infection WoW%],1)&"%"
          Infection WOW% Color = IF([Infection WoW%]>0,"#fa8264","#1c9407")


Steps for this report

Go to our report page to work on our card for Infection WOW %.

1. Drag and drop card from visualization.

2. Drag and drop Infection WOW% sign measure from measure table in fields.

3. Add a title text and use same format through out the dashboard. (Refer step 4)

4. Customize Data label

5. Category - off

6.  Boarder - on



DAX time intelligence explained:
(https://exceleratorbi.com.au/dax-time-intelligence-beginners/)

How to add YOY, WOW, QOQ, MOM analysis in power Bi?
(https://www.youtube.com/watch?v=UnbmjegqALc)